	gen stateansi = floor(fips/1000)
	gen state = "AL" if stateansi == 1
	replace state = "AK" if stateansi == 2
	replace state = "AZ" if stateansi == 4
	replace state = "AR" if stateansi == 5
	replace state = "CA" if stateansi == 6
	replace state = "CO" if stateansi == 8
	replace state = "CT" if stateansi == 9
	replace state = "DE" if stateansi == 10
	replace state = "DC" if stateansi == 11
	replace state = "FL" if stateansi == 12
	replace state = "GA" if stateansi == 13
	replace state = "HI" if stateansi == 15
	replace state = "ID" if stateansi == 16
	replace state = "IL" if stateansi == 17
	replace state = "IN" if stateansi == 18
	replace state = "IA" if stateansi == 19
	replace state = "KS" if stateansi == 20
	replace state = "KY" if stateansi == 21
	replace state = "LA" if stateansi == 22
	replace state = "ME" if stateansi == 23	
	replace state = "MD" if stateansi == 24
	replace state = "MA" if stateansi == 25	
	replace state = "MI" if stateansi == 26
	replace state = "MN" if stateansi == 27
	replace state = "MS" if stateansi == 28
	replace state = "MO" if stateansi == 29
	replace state = "MT" if stateansi == 30
	replace state = "NE" if stateansi == 31
	replace state = "NV" if stateansi == 32
	replace state = "NH" if stateansi == 33
	replace state = "NJ" if stateansi == 34
	replace state = "NM" if stateansi == 35
	replace state = "NY" if stateansi == 36
	replace state = "NC" if stateansi == 37
	replace state = "ND" if stateansi == 38
	replace state = "OH" if stateansi == 39
	replace state = "OK" if stateansi == 40
	replace state = "OR" if stateansi == 41
	replace state = "PA" if stateansi == 42
	replace state = "RI" if stateansi == 44	
	replace state = "SC" if stateansi == 45
	replace state = "SD" if stateansi == 46
	replace state = "TN" if stateansi == 47
	replace state = "TX" if stateansi == 48
	replace state = "UT" if stateansi == 49
	replace state = "VT" if stateansi == 50	
	replace state = "VA" if stateansi == 51
	replace state = "WA" if stateansi == 53	
	replace state = "WV" if stateansi == 54
	replace state = "WI" if stateansi == 55
	replace state = "WY" if stateansi == 56
